{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PROJECT INFO","CONDUIT SIZING"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":152,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PROJECT INFO","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[5,0,6,2],[0,0,1,2],[2,2,4,2]]}
["PROJECT INFORMATION"]
[]
["PROJECT/PID:"]
["INTERSECTION NAME:"]
["STUDY DATE:"]

{"sheet":"CONDUIT SIZING","index":1,"n_rows":53,"n_cols":43,"rows_kept":53,"cut":false,"hidden":false,"merged":[[34,13,48,13],[34,14,48,14],[34,0,48,0],[34,4,48,4],[34,1,48,1],[34,2,48,2],[34,3,48,3],[34,12,48,12],[34,5,48,5],[34,6,48,6],[0,0,0,6],[1,9,3,9],[1,8,3,8],[1,2,2,2],[1,0,3,0],[1,1,3,1],[1,3,2,3],[1,4,2,4],[1,7,3,7],[0,7,0,12],[4,13,18,13],[4,14,18,14],[19,13,33,13],[4,12,18,12],[19,12,33,12],[19,14,33,14],[3,22,3,24],[1,10,3,10],[3,16,3,20],[0,13,3,13],[0,14,2,14],[19,0,33,0],[19,1,33,1],[19,2,33,2],[19,3,33,3],[4,6,18,6],[19,5,33,5],[19,6,33,6],[19,4,33,4],[4,4,18,4],[4,5,18,5],[4,0,18,0],[4,1,18,1],[4,2,18,2],[4,3,18,3]]}
["CONDUIT",null,null,null,null,null,null,"CABLE AND WIRE",null,null,null,null,null,"IS [A] LESS THAN 0.25C?","FINAL CONDUIT  NOMINAL DIAMETER"]
["FROM","TO","RUN LENGTH","SIZE/NOMINAL DIAMETER","INSIDE DIAMETER","C","0.25C","CABLE USE","SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","NO. CABLES OR WIRES*","a","[A]",null,null,null,null,null,null,null,null,null,"Used to calulate area:",null,null,null,"Specification or Material lookup:"]
[null,null,null,null,null,"INSIDE AREA","25% INSIDE AREA",null,null,null,null,"CROSS SECTION AREA","COMBINED CROSS SECTION AREA"]
[null,null,"FT.","IN.","IN.","SQ. IN.","SQ. IN.",null,null,null,null,"SQ. IN.","SQ. IN.",null,"IN.",null,"CONDUIT CROSS SECTION AREA",null,null,null,null,null,"CROSS SECTION AREA OF CABLE AND WIRE",null,null,null,"-","IMSA 19-1 OR 20-1","RHH/RHW/USE","ETHERNET CAT 5E ARMORED","SMARTSENSOR 6 CONDUCTOR","IMSA 50-2","RG-6/V (COAX)","RG-6/V WITH POWER (COAX)","RG-8/U (COAX)","SMARTSENSOR 8 CONDUCTOR","FIBER, 6 STRAND","FIBER, 12 STRAND","FIBER, 24 STRAND","FIBER, 48 STRAND","FIBER, 72 STRAND","FIBER, 144 STRAND","FIBER, 288 STRAND"]
["-","-","-","-",{"$f":"VLOOKUP(D5,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D5,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D5,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-",{"$f":"IF(K5=\"-\",\"-\",(K5*INDEX($Y$6:$Y$53,MATCH(1,INDEX((I5=$W$6:$W$53)*(J5=$X$6:$X$53),0),0))))","v":"-"},{"$f":"IF(L5=\"-\",\"-\",SUMIF(L5:L19,\">0\"))","v":"-"},{"$f":"IF(M5=\"-\",\"-\",IF(M5<=G5, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N5=\"-\",\"-\",IF(N5=\"YES\",D5,INDEX($R$19:$R$28,MATCH(M5,$S$19:$S$28,-1))))","v":"-"},null,"0.4 AREA","NOMINAL DIAMETER","INSIDE DIAMETER","INSIDE AREA ","0.25 AREA",null,"SPECIFICATION OR MATERIAL","NO. OF CONDUCTORS AWG","CROSS SECTION AREA, SQ. IN.",null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,"-","-","-","-",{"$f":"IF(K6=\"-\",\"-\",(K6*INDEX($Y$6:$Y$53,MATCH(1,INDEX((I6=$W$6:$W$53)*(J6=$X$6:$X$53),0),0))))","v":"-"},null,null,null,null,"-","-","-","-","-",null,"-","-","-",null,null,"2/C # 14","1/C # 14","8/C # 24","6/C # 20","2/C # 14","1/C # 18","1/C # 18 (COAX)","1/C # 11","8/C # 20","6 STRAND","12 STRAND","24 STRAND","48 STRAND","72 STRAND","144 STRAND","288 STRAND"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,{"$f":"0.25*T7","v":7.4999999999999997E-2},0.5,0.622,0.3,{"$f":"0.25*T7","v":7.4999999999999997E-2},null,"IMSA 19-1 OR 20-1","2/C # 12",0.12,null,null,"3/C # 14","1/C # 12",null,null,null,null,"2/C # 16 (POWER)"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,{"$f":"0.25*T8","v":0.13250000000000001},0.75,0.82399999999999995,0.53,{"$f":"0.25*T8","v":0.13250000000000001},null,"IMSA 19-1 OR 20-1","2/C # 14",0.1,null,null,"4/C # 14","1/C # 10"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,0.215,1,1.0489999999999999,0.86,0.215,null,"IMSA 19-1 OR 20-1","3/C # 12",0.16,null,null,"5/C # 14","1/C # 8"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,0.375,1.25,1.38,1.5,0.375,null,"IMSA 19-1 OR 20-1","3/C # 14",0.13,null,null,"7/C # 14","1/C # 6"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,0.51,1.5,1.61,2.04,0.51,null,"IMSA 19-1 OR 20-1","4/C # 12",0.19,null,null,"9/C # 14","1/C # 4"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,0.84,2,2.0670000000000002,3.36,0.84,null,"IMSA 19-1 OR 20-1","4/C # 14",0.16,null,null,"12/C # 14","1/C # 2"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,1.1975,2.5,2.4689999999999999,4.79,1.1975,null,"IMSA 19-1 OR 20-1","5/C # 12",0.23,null,null,"15/C # 14","1/C # 1"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,1.845,3,3.0680000000000001,7.38,1.845,null,"IMSA 19-1 OR 20-1","5/C # 14",0.19,null,null,"18/C # 14","1/C # 1/0"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,2.4750000000000001,3.5,3.548,9.9,2.4750000000000001,null,"IMSA 19-1 OR 20-1","7/C # 12",0.3,null,null,"25/C # 14","1/C # 2/0"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,3.18,4,4.0259999999999998,12.72,3.18,null,"IMSA 19-1 OR 20-1","7/C # 14",0.22,null,null,"2/C # 12","1/C # 3/0"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"IMSA 19-1 OR 20-1","9/C # 12",0.4,null,null,"3/C # 12","1/C # 4/0"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,"NOMINAL DIAMETER","0.25 AREA",null,null,null,"IMSA 19-1 OR 20-1","9/C # 14",0.33,null,null,"4/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,4,3.18,null,null,null,"IMSA 19-1 OR 20-1","12/C # 12",0.5,null,null,"5/C # 12"]
["-","-","-","-",{"$f":"VLOOKUP(D20,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D20,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D20,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L20=\"-\",\"-\",SUMIF(L20:L34,\">0\"))","v":"-"},{"$f":"IF(M20=\"-\",\"-\",IF(M20<=G20, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N20=\"-\",\"-\",IF(N20=\"YES\",D20,INDEX($R$19:$R$28,MATCH(M20,$S$19:$S$28,-1))))","v":"-"},null,null,3.5,2.48,null,null,null,"IMSA 19-1 OR 20-1","12/C # 14",0.41,null,null,"7/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,3,1.85,null,null,null,"IMSA 19-1 OR 20-1","15/C #12",0.57999999999999996,null,null,"9/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,2.5,1.2,null,null,null,"IMSA 19-1 OR 20-1","15/C # 14",0.48,null,null,"12/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,2,0.84,null,null,null,"IMSA 19-1 OR 20-1","18/C # 12",0.74,null,null,"15/C #12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,1.5,0.51,null,null,null,"IMSA 19-1 OR 20-1","18/C # 14",0.55000000000000004,null,null,"18/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,1.25,0.38,null,null,null,"IMSA 19-1 OR 20-1","25/C # 12",1,null,null,"25/C # 12"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,1,0.22,null,null,null,"IMSA 19-1 OR 20-1","25/C # 14",0.82]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,0.75,0.13,null,null,null,"RHH/RHW/USE","1/C # 2",0.22900000000000001,null,"Cable Use:"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,0.5,0.08,null,null,null,"RHH/RHW/USE","1/C # 4",0.17299999999999999,null,"-","SIGNALS","POWER/LIGHTING","COMMUNICATIONS","WAVETRONIX RADAR","LOOP LEAD-IN","VIDEO","RADIO ANTENNA"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 6",0.13800000000000001,null,"-","-","-","-","-","-","-","-"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 8",0.107,null,null,"IMSA 19-1 OR 20-1","RHH/RHW/USE","ETHERNET CAT 5E ARMORED","SMARTSENSOR 6 CONDUCTOR","IMSA 50-2","RG-6/V (COAX)","RG-8/U (COAX)"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 10",7.4999999999999997E-2,null,null,null,null,"FIBER, 6 STRAND","SMARTSENSOR 8 CONDUCTOR",null,"RG-6/V WITH POWER (COAX)"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 12",6.0999999999999999E-2,null,null,null,null,"FIBER, 12 STRAND"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 14",5.2999999999999999E-2,null,null,null,null,"FIBER, 24 STRAND"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"ETHERNET CAT 5E ARMORED","8/C # 24",0.13,null,null,null,null,"FIBER, 48 STRAND"]
["-","-","-","-",{"$f":"VLOOKUP(D35,$R$6:$T$16,2,FALSE)","v":"-"},{"$f":"VLOOKUP(D35,$R$6:$T$16,3,FALSE)","v":"-"},{"$f":"VLOOKUP(D35,$R$6:$U$16,4,FALSE)","v":"-"},"-","-","-","-","-",{"$f":"IF(L35=\"-\",\"-\",SUMIF(L35:L49,\">0\"))","v":"-"},{"$f":"IF(M35=\"-\",\"-\",IF(M35<=G35, \"YES\", \"NO\"))","v":"-"},{"$f":"IF(N35=\"-\",\"-\",IF(N35=\"YES\",D35,INDEX($R$19:$R$28,MATCH(M35,$S$19:$S$28,-1))))","v":"-"},null,null,null,null,null,null,null,"SMARTSENSOR 6 CONDUCTOR","6/C # 20",0.17,null,null,null,null,"FIBER, 72 STRAND"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"IMSA 50-2","2/C # 14",0.1,null,null,null,null,"FIBER, 144 STRAND"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RG-6/V (COAX)","1/C # 18",0.06,null,null,null,null,"FIBER, 288 STRAND"]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RG-6/V WITH POWER (COAX)","1/C # 18 (COAX)",0.16]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RG-6/V WITH POWER (COAX)","2/C # 16 (POWER)",0.16]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RG-8/U (COAX)","1/C # 11",0.13]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"SMARTSENSOR 8 CONDUCTOR","8/C # 20",0.17]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"FIBER, 6 STRAND","6 STRAND",0.2]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"FIBER, 12 STRAND","12 STRAND",0.2]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"FIBER, 24 STRAND","24 STRAND",0.2]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"FIBER, 48 STRAND","48 STRAND",0.2]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"FIBER, 72 STRAND","72 STRAND",0.2]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"FIBER, 144 STRAND","144 STRAND",0.42]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"FIBER, 288 STRAND","288 STRAND",0.56000000000000005]
[null,null,null,null,null,null,null,"-","-","-","-","-",null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 1",0.245,null,"Got new power cable info from:",null,"http://www.standard-wire.com/downloads/SWC_Catalog.pdf"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 1/0",0.30249999999999999,null,"REMEMBER TO CONVERT ALL TO SQ. IN!!!!!!!!!!!!!!!!!!!"]
["* NOTE: INCLUDE GROUNDING CONDUCTOR IN WIRE COUNT FOR LIGHTING CIRCUITS OF NOTATION \"WITH GROUND.\"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 2/0",0.37209999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 3/0",0.43559999999999999]
["(Use additional spreadsheets for additional conduit runs)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RHH/RHW/USE","1/C # 4/0",0.53290000000000004]